package com.rx.substation.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import com.rx.substation.service.ExportService;

import java.io.IOException;

/**
 *	一般excel表格导出
 * @author dcx
 *
 */

@RestController
@Component
@RequestMapping(value = "/excelexport")
public class ExcelExportController {

	@Autowired
	ExportService exportService;

	/**
	 * 一般标准表格导出
	 * @param request
	 * @param response
	 */
//	@RequestMapping(value="/excel/normalexport",produces="application/json;charset=UTF-8",method = RequestMethod.POST)
	@RequestMapping(value="/excel/normalexport",produces="application/json;charset=UTF-8")
	@ResponseBody
	public void exportExcel(HttpServletRequest request, HttpServletResponse response){
//		String tableName = request.getParameter("excelName");
//		String cellValues = request.getParameter("cellValues");

		String excelName = "dcx";
			String cellValues = "<table class=\"table table-striped table-bordered table-hover table-checkable thcenter\" style=\"background-color:#fff\"><thead><tr><th rowspan=\"2\">市州</th><th colspan=\"3\">2017年1-4月平均浓度（微克/立方米）</th><th colspan=\"3\">2016年1-4月平均浓度（微克/立方米）</th><th colspan=\"5\">同比2016年1-4月改善率(%)</th><th rowspan=\"2\">各市(州)PM10完成目标比例(%)</th><th rowspan=\"2\">省政府下达PM10年度目标扣收资金（万元）</th><th rowspan=\"2\">同比2016年改善资金（万元）</th><th rowspan=\"2\">总得资金（万元）</th></tr><tr><th>PM10</th><th>SO2</th><th>NO2</th><th>PM10</th><th>SO2</th><th>NO2</th><th>PM10</th><th>SO2</th><th>NO2</th><th>空气质量(三类污染物权重核算)</th><th>占全省改善率比例(%)</th></tr></thead><tbody><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr成都市\"><td>成都市</td><td datatype=\"PM10\" beforevalue=\"118.2\">118.2</td><td datatype=\"SO2\" beforevalue=\"14.3\">14.3</td><td datatype=\"NO2\" beforevalue=\"59.6\">59.6</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"118.9\">118.9</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"14.5\">14.5</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"58.8\">58.8</td><td datatype=\"PM10_TB_2016\" beforevalue=\"0.58873\">0.6%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"1.3793103\">1.4%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-1.3605442\">-1.4%</td><td datatype=\"TB_GS_2016\" beforevalue=\"0.4\">0.4%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"0.5111581505230594\">0.5%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr自贡市\"><td>自贡市</td><td datatype=\"PM10\" beforevalue=\"113.8\">113.8</td><td datatype=\"SO2\" beforevalue=\"18.9\">18.9</td><td datatype=\"NO2\" beforevalue=\"40.5\">40.5</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"123.5\">123.5</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"13.2\">13.2</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"32.9\">32.9</td><td datatype=\"PM10_TB_2016\" beforevalue=\"7.854251\">7.9%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-43.18182\">-43.2%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-23.100304\">-23.1%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-8.5\">-8.5%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr攀枝花市\"><td>攀枝花市</td><td datatype=\"PM10\" beforevalue=\"77.2\">77.2</td><td datatype=\"SO2\" beforevalue=\"40.4\">40.4</td><td datatype=\"NO2\" beforevalue=\"37.9\">37.9</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"72.1\">72.1</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"34.1\">34.1</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"33.1\">33.1</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-7.073509\">-7.1%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-18.475073\">-18.5%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-14.501511\">-14.5%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-10.8\">-10.8%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr泸州市\"><td>泸州市</td><td datatype=\"PM10\" beforevalue=\"106.7\">106.7</td><td datatype=\"SO2\" beforevalue=\"23\">23.0</td><td datatype=\"NO2\" beforevalue=\"37\">37.0</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"97\">97.0</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"19.1\">19.1</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"31.8\">31.8</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-10\">-10.0%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-20.418848\">-20.4%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-16.352201\">-16.4%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-13.4\">-13.4%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr德阳市\"><td>德阳市</td><td datatype=\"PM10\" beforevalue=\"111.3\">111.3</td><td datatype=\"SO2\" beforevalue=\"10.2\">10.2</td><td datatype=\"NO2\" beforevalue=\"34.2\">34.2</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"109.4\">109.4</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"11.9\">11.9</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"32.7\">32.7</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-1.736746\">-1.7%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"14.285714\">14.3%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-4.587156\">-4.6%</td><td datatype=\"TB_GS_2016\" beforevalue=\"0.9\">0.9%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"1.2853211048887128\">1.3%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr绵阳市\"><td>绵阳市</td><td datatype=\"PM10\" beforevalue=\"89.6\">89.6</td><td datatype=\"SO2\" beforevalue=\"10.6\">10.6</td><td datatype=\"NO2\" beforevalue=\"39.2\">39.2</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"100.6\">100.6</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"11.5\">11.5</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"39.7\">39.7</td><td datatype=\"PM10_TB_2016\" beforevalue=\"10.934394\">10.9%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"7.826087\">7.8%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"1.2594458\">1.3%</td><td datatype=\"TB_GS_2016\" beforevalue=\"8.4\">8.4%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"11.995678356441198\">12.0%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr广元市\"><td>广元市</td><td datatype=\"PM10\" beforevalue=\"90.4\">90.4</td><td datatype=\"SO2\" beforevalue=\"19.9\">19.9</td><td datatype=\"NO2\" beforevalue=\"42.2\">42.2</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"88.3\">88.3</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"20\">20.0</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"39.6\">39.6</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-2.3782558\">-2.4%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"0.5\">0.5%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-6.5656567\">-6.6%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-2.6\">-2.6%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr遂宁市\"><td>遂宁市</td><td datatype=\"PM10\" beforevalue=\"78.4\">78.4</td><td datatype=\"SO2\" beforevalue=\"15.2\">15.2</td><td datatype=\"NO2\" beforevalue=\"26.1\">26.1</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"84.6\">84.6</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"12.2\">12.2</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"31.3\">31.3</td><td datatype=\"PM10_TB_2016\" beforevalue=\"7.328605\">7.3%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-24.590164\">-24.6%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"16.613419\">16.6%</td><td datatype=\"TB_GS_2016\" beforevalue=\"2.8\">2.8%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"4.011779762259797\">4.0%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr内江市\"><td>内江市</td><td datatype=\"PM10\" beforevalue=\"93.7\">93.7</td><td datatype=\"SO2\" beforevalue=\"18.4\">18.4</td><td datatype=\"NO2\" beforevalue=\"29.6\">29.6</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"85.4\">85.4</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"19.4\">19.4</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"32.4\">32.4</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-9.718969\">-9.7%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"5.1546392\">5.2%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"8.641975\">8.6%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-3.1\">-3.1%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr乐山市\"><td>乐山市</td><td datatype=\"PM10\" beforevalue=\"110.8\">110.8</td><td datatype=\"SO2\" beforevalue=\"15.4\">15.4</td><td datatype=\"NO2\" beforevalue=\"39.4\">39.4</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"95.1\">95.1</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"19.4\">19.4</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"39.4\">39.4</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-16.508938\">-16.5%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"20.618557\">20.6%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"0\">0.0%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-5.8\">-5.8%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr南充市\"><td>南充市</td><td datatype=\"PM10\" beforevalue=\"86.4\">86.4</td><td datatype=\"SO2\" beforevalue=\"11.4\">11.4</td><td datatype=\"NO2\" beforevalue=\"39.2\">39.2</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"102.1\">102.1</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"9.8\">9.8</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"36.4\">36.4</td><td datatype=\"PM10_TB_2016\" beforevalue=\"15.377081\">15.4%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-16.32653\">-16.3%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-7.6923075\">-7.7%</td><td datatype=\"TB_GS_2016\" beforevalue=\"4.4\">4.4%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"6.3323331723112855\">6.3%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr眉山市\"><td>眉山市</td><td datatype=\"PM10\" beforevalue=\"106.7\">106.7</td><td datatype=\"SO2\" beforevalue=\"17.3\">17.3</td><td datatype=\"NO2\" beforevalue=\"46.8\">46.8</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"102.4\">102.4</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"15.5\">15.5</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"35\">35.0</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-4.1992188\">-4.2%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-11.612904\">-11.6%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-33.714287\">-33.7%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-11.6\">-11.6%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr宜宾市\"><td>宜宾市</td><td datatype=\"PM10\" beforevalue=\"98.8\">98.8</td><td datatype=\"SO2\" beforevalue=\"20.8\">20.8</td><td datatype=\"NO2\" beforevalue=\"38.7\">38.7</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"95.7\">95.7</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"20.3\">20.3</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"33.3\">33.3</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-3.2392893\">-3.2%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-2.4630542\">-2.5%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-16.216217\">-16.2%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-5.7\">-5.7%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr广安市\"><td>广安市</td><td datatype=\"PM10\" beforevalue=\"101.3\">101.3</td><td datatype=\"SO2\" beforevalue=\"18.2\">18.2</td><td datatype=\"NO2\" beforevalue=\"32.7\">32.7</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"89.5\">89.5</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"21.5\">21.5</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"28.2\">28.2</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-13.184358\">-13.2%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"15.348837\">15.3%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-15.957447\">-16.0%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-8\">-8.0%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr达州市\"><td>达州市</td><td datatype=\"PM10\" beforevalue=\"97\">97.0</td><td datatype=\"SO2\" beforevalue=\"10.1\">10.1</td><td datatype=\"NO2\" beforevalue=\"39.5\">39.5</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"107.5\">107.5</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"13.4\">13.4</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"46.4\">46.4</td><td datatype=\"PM10_TB_2016\" beforevalue=\"9.767442\">9.8%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"24.626865\">24.6%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"14.870689\">14.9%</td><td datatype=\"TB_GS_2016\" beforevalue=\"13.8\">13.8%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"19.702233476286825\">19.7%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr雅安市\"><td>雅安市</td><td datatype=\"PM10\" beforevalue=\"87.8\">87.8</td><td datatype=\"SO2\" beforevalue=\"11.7\">11.7</td><td datatype=\"NO2\" beforevalue=\"35\">35.0</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"77.2\">77.2</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"8.4\">8.4</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"28.9\">28.9</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-13.73057\">-13.7%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-39.285713\">-39.3%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-21.107265\">-21.1%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-20.3\">-20.3%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr巴中市\"><td>巴中市</td><td datatype=\"PM10\" beforevalue=\"70.4\">70.4</td><td datatype=\"SO2\" beforevalue=\"4.2\">4.2</td><td datatype=\"NO2\" beforevalue=\"32.9\">32.9</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"80.9\">80.9</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"5.5\">5.5</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"38.5\">38.5</td><td datatype=\"PM10_TB_2016\" beforevalue=\"12.978987\">13.0%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"23.636364\">23.6%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"14.545454\">14.5%</td><td datatype=\"TB_GS_2016\" beforevalue=\"15.4\">15.4%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"22.084517784852263\">22.1%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr资阳市\"><td>资阳市</td><td datatype=\"PM10\" beforevalue=\"112.6\">112.6</td><td datatype=\"SO2\" beforevalue=\"11.8\">11.8</td><td datatype=\"NO2\" beforevalue=\"26.6\">26.6</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"109.5\">109.5</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"22.4\">22.4</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"20.6\">20.6</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-2.8310502\">-2.8%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"47.32143\">47.3%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-29.126213\">-29.1%</td><td datatype=\"TB_GS_2016\" beforevalue=\"1.9\">1.9%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"2.7783824980396608\">2.8%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr马尔康市\"><td>马尔康市</td><td datatype=\"PM10\" beforevalue=\"27.6\">27.6</td><td datatype=\"SO2\" beforevalue=\"8.4\">8.4</td><td datatype=\"NO2\" beforevalue=\"9.3\">9.3</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"38.6\">38.6</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"7.1\">7.1</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"14.6\">14.6</td><td datatype=\"PM10_TB_2016\" beforevalue=\"28.49741\">28.5%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-18.309858\">-18.3%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"36.30137\">36.3%</td><td datatype=\"TB_GS_2016\" beforevalue=\"20.7\">20.7%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"29.634656379608277\">29.6%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr康定市\"><td>康定市</td><td datatype=\"PM10\" beforevalue=\"36.4\">36.4</td><td datatype=\"SO2\" beforevalue=\"21.9\">21.9</td><td datatype=\"NO2\" beforevalue=\"33.5\">33.5</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"43.3\">43.3</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"15.7\">15.7</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"25.6\">25.6</td><td datatype=\"PM10_TB_2016\" beforevalue=\"15.935335\">15.9%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-39.490444\">-39.5%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-30.859375\">-30.9%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-4.5\">-4.5%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr class=\"MoneyTableDataTr\" citycode=\"MoneyTableTr西昌市\"><td>西昌市</td><td datatype=\"PM10\" beforevalue=\"44\">44.0</td><td datatype=\"SO2\" beforevalue=\"20.9\">20.9</td><td datatype=\"NO2\" beforevalue=\"24.9\">24.9</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"44\">44.0</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"25.8\">25.8</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"22\">22.0</td><td datatype=\"PM10_TB_2016\" beforevalue=\"0\">0.0%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"18.992249\">19.0%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-13.181818\">-13.2%</td><td datatype=\"TB_GS_2016\" beforevalue=\"1.2\">1.2%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"1.6639339892633036\">1.7%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0\">0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0\">0</td></tr><tr citycode=\"MoneyTableTrAVG\"><td>全省平均</td><td datatype=\"PM10\" beforevalue=\"88.52857143\">88.5</td><td datatype=\"SO2\" beforevalue=\"16.33333333\">16.3</td><td datatype=\"NO2\" beforevalue=\"35.46666667\">35.5</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"88.83809524\">88.8</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"16.22380952\">16.2</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"33.39047619\">33.4</td><td datatype=\"PM10_TB_2016\" beforevalue=\"0.33783784\">0.3%</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-0.61728395\">-0.6%</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-6.28742515\">-6.3%</td><td datatype=\"TB_GS_2016\" beforevalue=\"-1.20000000\">-1.2%</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"-\">-</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"-\">-</td></tr><tr citycode=\"MoneyTableTrTotal\"><td>总计</td><td datatype=\"PM10\" beforevalue=\"-\">-</td><td datatype=\"SO2\" beforevalue=\"-\">-</td><td datatype=\"NO2\" beforevalue=\"-\">-</td><td datatype=\"PM10_TB_AVG_2016\" beforevalue=\"-\">-</td><td datatype=\"SO2_TB_AVG_2016\" beforevalue=\"-\">-</td><td datatype=\"NO2_TB_AVG_2016\" beforevalue=\"-\">-</td><td datatype=\"PM10_TB_2016\" beforevalue=\"-\">-</td><td datatype=\"SO2_TB_2016\" beforevalue=\"-\">-</td><td datatype=\"NO2_TB_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_GS_2016\" beforevalue=\"-\">-</td><td datatype=\"TB_GS_ZB_2016\" beforevalue=\"99.99999467\">100.0%</td><td datatype=\"PM10_LJCOV\" beforevalue=\"-\">-</td><td datatype=\"PM10_KSZJ\" beforevalue=\"0.00000000\">0.0</td><td datatype=\"TB_GSZJ_2016\" beforevalue=\"0.00000000\">0.0</td><td datatype=\"TB_TOTALZJ\" beforevalue=\"0.00000000\">0.0</td></tr></tbody></table>";
		try {
			exportService.export(response,excelName,cellValues);
		}catch (IOException e){
			e.printStackTrace();
		}
	}

}
